﻿namespace LASLogic.BusinessLayer.Utilities
{
    public class Constants
    {

        #region XML Constants

        public const string ROOT_NODE_BEGINNING = "<root>";
        public const string ROOT_NODE_ENDING = "</root>";

        #endregion
        
        #region XML Tags
        
        public const string NODE_NAME_ENTRY = "NODE_NAME_ENTRY";
        public const string NODE_NAME_TRANSACTION_TYPE = "NODE_NAME_TRANSACTION_TYPE";
        public const string NODE_NAME_ACCOUNT_RELATION = "NODE_NAME_ACCOUNT_RELATION";
        public const string TAG_NAME_GET_ALL_ENTRIES_ENTRY_ID = "TAG_NAME_GET_ALL_ENTRIES_ENTRY_ID";
        public const string TAG_NAME_GET_ALL_ENTRIES_COMPANY_ID = "TAG_NAME_GET_ALL_ENTRIES_COMPANY_ID";
        public const string TAG_NAME_GET_ALL_ENTRIES_MONTH_ID = "TAG_NAME_GET_ALL_ENTRIES_MONTH_ID";
        public const string TAG_NAME_GET_ALL_ENTRIES_PERIOD_ID = "TAG_NAME_GET_ALL_ENTRIES_PERIOD_ID";
        public const string TAG_NAME_GET_ALL_ENTRIES_USER_ID = "TAG_NAME_GET_ALL_ENTRIES_USER_ID";
        public const string TAG_NAME_GET_ALL_ENTRIES_COMPANY_NAME = "TAG_NAME_GET_ALL_ENTRIES_COMPANY_NAME";
        public const string TAG_NAME_GET_ALL_ENTRIES_NAME = "TAG_NAME_GET_ALL_ENTRIES_NAME";
        public const string TAG_NAME_GET_ALL_ENTRIES_ENTRY_UNIQUE_ID = "TAG_NAME_GET_ALL_ENTRIES_ENTRY_UNIQUE_ID";
        public const string TAG_NAME_GET_ALL_ENTRIES_DOCUMENT_DATE = "TAG_NAME_GET_ALL_ENTRIES_DOCUMENT_DATE";
        public const string TAG_NAME_GET_ALL_ENTRIES_ACCOUNTED_DATE = "TAG_NAME_GET_ALL_ENTRIES_ACCOUNTED_DATE";
        public const string TAG_NAME_GET_ALL_ENTRIES_COMMENTS = "TAG_NAME_GET_ALL_ENTRIES_COMMENTS";
        public const string TAG_NAME_GET_ALL_ENTRIES_REFERENCE1 = "TAG_NAME_GET_ALL_ENTRIES_REFERENCE1";
        public const string TAG_NAME_GET_ALL_ENTRIES_REFERENCE2 = "TAG_NAME_GET_ALL_ENTRIES_REFERENCE2";
        public const string TAG_NAME_GET_ALL_ENTRIES_REFERENCE3 = "TAG_NAME_GET_ALL_ENTRIES_REFERENCE3";
        public const string TAG_NAME_GET_ALL_ENTRIES_ENTRY_TYPE = "TAG_NAME_GET_ALL_ENTRIES_ENTRY_TYPE";
        public const string TAG_NAME_GET_ALL_ENTRIES_MONTH_STATUS = "TAG_NAME_GET_ALL_ENTRIES_MONTH_STATUS";
        public const string TAG_NAME_GET_ALL_ENTRIES_TRANSACTION_TYPE = "TAG_NAME_GET_ALL_ENTRIES_TRANSACTION_TYPE";
        public const string TAG_NAME_GET_ALL_ENTRIES_ACCOUNT_ID = "TAG_NAME_GET_ALL_ENTRIES_ACCOUNT_ID";
        public const string TAG_NAME_GET_ALL_ENTRIES_BALANCE = "TAG_NAME_GET_ALL_ENTRIES_BALANCE";
        public const string TAG_NAME_GET_ALL_ENTRIES_SYSTEM_BALANCE = "TAG_NAME_GET_ALL_ENTRIES_SYSTEM_BALANCE";
        public const string TAG_NAME_GET_ALL_ENTRIES_FOREIGN_BALANCE = "TAG_NAME_GET_ALL_ENTRIES_FOREIGN_BALANCE";
        public const string TAG_NAME_GET_ALL_ENTRIES_EXCHANGE_RATE = "TAG_NAME_GET_ALL_ENTRIES_EXCHANGE_RATE";

        #endregion

        #region Business Constants
        
        public const string DEBIT_NAME = "DEBIT_NAME";
        public const string CREDIT_NAME = "CREDIT_NAME"; 
        public const string ACCOUNT_TYPE_TITLE = "ACCOUNT_TYPE_TITLE";
        public const string ACCOUNT_TYPE_ACTIVE = "ACCOUNT_TYPE_ACTIVE";
        public const string ACCOUNT_STATUS_ACTIVE = "ACCOUNT_STATUS_ACTIVE";
        public const string ACCOUNT_STATUS_ERASED = "ACCOUNT_STATUS_ERASED";


        public const string BALANCE_SHEET_FORMAT_HEADER = "\t\t\t{0}\n\t\t\tBalance de Comprobación\n\t\t\t\tAl {1}\n";
        public const string BALANCE_SHEET_FORMAT_INNER = "                           \t\t\t{0}\t               \t{1}\n";
        public const string BALANCE_SHEET_FORMAT_BOTTOM = "                     \t\t________________________________________________\n                           \t\t\t{0}\t\t{1}";


        public const string INCOME_STATEMENT_FORMAT_HEADER =
            "\t\t\t{0}\n\t\tEstado de resultados y utilidades retenidas\n\t\t\tAl {1}\n";

        public const string INCOME_STATEMENT_FORMAT_OUTLINE =
            "INGRESOS OPERATIVOS\n{0}{5}\nEGRESOS OPERATIVOS\n{1}{6}{4}\nUtilidad Operativa                                   {8}{2}\n\nPARTIDAS EXTRAORDINARIAS\n\n{3}{4}\n{7}\n";

        public const string INCOME_STATEMENT_FORMAT_DIV =
            "                  \t\t_________________________________________";
        public const string INCOME_STATEMENT_FORMAT_ACCOUNT =
            "                                     {1}{0}         \n";
        public const string INCOME_STATEMENT_FORMAT_FINANCE =
            "Ingresos Financieros                 {2}{0}         \nEgresos Financieros                  {2}{1}         \n";

        public const string INCOME_STATEMENT_FORMAT_TOTAL_INCOME = "Total Ingresos                                       {1}{0}\n";
        public const string INCOME_STATEMENT_FORMAT_TOTAL_EXPENSES = "Total Gastos                                         {1}{0}\n";
        public const string INCOME_STATEMENT_FORMAT_TOTAL_EXTRA = "Total Partidas Extraordinarias                       {1}{0}\n";
        public const string INCOME_STATEMENT_FORMAT_BOTTOM =
            "Utilidad antes de impuesto                           {8}{0}\nImpuesto de renta                                   ({8}{1})\nUtilidad neta del periodo                            {8}{2}\n\nUtilidades retenidas del {6}\t                     {8}{3}\nDividendos                                          ({8}{4})\nUtilidades retenidas del {7}\t                     {8}{5}\n";
        
        public const string GENERAL_BALANCE_FORMAT_HEADER = "\t\t\t{0}\n\t\t\tBalance General\n\t\t\t\tAl {1}\n";
        public const string GENERAL_BALANCE_FORMAT_ACCOUNT =
    "                                     {1}{0}         \n";
        public const string GENERAL_BALANCE_FORMAT_OUTLINE =
            "ACTIVOS\nCirculantes\n{0}\nFijos\n{1}\nOtros\n{2}\nTOTAL ACTIVOS                                                             {10}{3}\n\nPASIVO Y PATRIMONIO\nPASIVO\nCirculante\n{4}\nFijos\n{5}\nOtros\n{6}\nTOTAL PASIVOS                                               {10}{7}\nPATRIMONIO\n{8}\nTOTAL PASIVOS Y PATRIMONIO                                               {10}{9}\n";


    
        public const string TAXES_PERCENTAGE = "TAXES_PERCENTAGE";
        public const string STOCK_DIVIDENDS_PERCENTAGE = "STOCK_DIVIDENDS_PERCENTAGE";

        public const string DB_CONN = "DATA_BASE_CONNECTION";
        //public const string DB_CONN = "REMOTE_DATABASE_CONNECTION";

        #endregion


        #region Stored Procedures

        public const string SP_NAME_INSERT_USER = "SP_NAME_INSERT_USER";
        public const string SP_PARAM_INSERT_USER_NAME = "SP_PARAM_INSERT_USER_NAME";
        public const string SP_PARAM_INSERT_USER_LASTNAME1 = "SP_PARAM_INSERT_USER_LASTNAME1";
        public const string SP_PARAM_INSERT_USER_LASTNAME2 = "SP_PARAM_INSERT_USER_LASTNAME2";
        public const string SP_PARAM_INSERT_USER_COMPANY_ID = "SP_PARAM_INSERT_USER_COMPANY_ID";
        public const string SP_PARAM_INSERT_USER_LOGIN = "SP_PARAM_INSERT_USER_LOGIN";
        public const string SP_PARAM_INSERT_USER_EMAIL = "SP_PARAM_INSERT_USER_EMAIL";
        public const string SP_PARAM_INSERT_USER_PASSWORD = "SP_PARAM_INSERT_USER_PASSWORD";

        public const string SP_NAME_USER_EXISTS = "SP_NAME_USER_EXISTS";
        public const string SP_PARAM_USER_EXISTS_LOGIN = "SP_PARAM_USER_EXISTS_LOGIN";

        public const string SP_NAME_INSERT_EXCHANGE_RATE = "SP_NAME_INSERT_EXCHANGE_RATE";
        public const string SP_PARAM_INSERT_EXCHANGE_RATE_COMPANY_ID = "SP_PARAM_INSERT_EXCHANGE_RATE_COMPANY_ID";
        public const string SP_PARAM_INSERT_EXCHANGE_RATE_CURRENCY_ID_BEGINING = "SP_PARAM_INSERT_EXCHANGE_RATE_CURRENCY_ID_BEGINING";
        public const string SP_PARAM_INSERT_EXCHANGE_RATE_CURRENCY_ID_DESTINY = "SP_PARAM_INSERT_EXCHANGE_RATE_CURRENCY_ID_DESTINY";
        public const string SP_PARAM_INSERT_EXCHANGE_RATE_START_DATE = "SP_PARAM_INSERT_EXCHANGE_RATE_START_DATE";
        public const string SP_PARAM_INSERT_EXCHANGE_RATE_FINISH_DATE = "SP_PARAM_INSERT_EXCHANGE_RATE_FINISH_DATE";
        public const string SP_PARAM_INSERT_EXCHANGE_RATE_EXCHANGE_RATE = "SP_PARAM_INSERT_EXCHANGE_RATE_EXCHANGE_RATE";

        public const string SP_NAME_GET_EXCHANGE_RATE = "SP_NAME_GET_EXCHANGE_RATE";
        public const string SP_PARAM_GET_EXCHANGE_RATE_COMPANY_ID = "SP_PARAM_GET_EXCHANGE_RATE_COMPANY_ID";
        public const string SP_PARAM_GET_EXCHANGE_RATE_FROM_CURRENCY = "SP_PARAM_GET_EXCHANGE_RATE_FROM_CURRENCY";
        public const string SP_PARAM_GET_EXCHANGE_RATE_TO_CURRENCY = "SP_PARAM_GET_EXCHANGE_RATE_TO_CURRENCY";
        public const string SP_PARAM_GET_EXCHANGE_RATE_ACTUAL_DATE = "SP_PARAM_GET_EXCHANGE_RATE_ACTUAL_DATE";
        public const string SP_OUTPUT_GET_EXCHANGE_RATE_EXCHANGE_RATE = "SP_OUTPUT_GET_EXCHANGE_RATE_EXCHANGE_RATE";

        public const string SP_NAME_INSERT_ACCOUNT_CATALOG = "SP_NAME_INSERT_ACCOUNT_CATALOG";
        public const string SP_PARAM_INSERT_ACCOUNT_CATALOG_COMPANY_ID = "SP_PARAM_INSERT_ACCOUNT_CATALOG_COMPANY_ID";

        public const string SP_NAME_INSERT_BOOK_ENTRY = "SP_NAME_INSERT_BOOK_ENTRY";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_PERIOD_ID = "SP_PARAM_INSERT_BOOK_ENTRY_PERIOD_ID";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_ENTRY_TYPE = "SP_PARAM_INSERT_BOOK_ENTRY_ENTRY_TYPE";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_COMPANY_ID = "SP_PARAM_INSERT_BOOK_ENTRY_COMPANY_ID";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_USER_ID = "SP_PARAM_INSERT_BOOK_ENTRY_USER_ID";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_DOCUMENT_DATE = "SP_PARAM_INSERT_BOOK_ENTRY_DOCUMENT_DATE";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_COMMENTS = "SP_PARAM_INSERT_BOOK_ENTRY_COMMENTS";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_REFERENCE_1 = "SP_PARAM_INSERT_BOOK_ENTRY_REFERENCE_1";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_REFERENCE_2 = "SP_PARAM_INSERT_BOOK_ENTRY_REFERENCE_2";
        public const string SP_PARAM_INSERT_BOOK_ENTRY_REFERENCE_3 = "SP_PARAM_INSERT_BOOK_ENTRY_REFERENCE_3";

        public const string SP_NAME_GET_USER = "SP_NAME_GET_USER";
        public const string SP_PARAM_GET_USER_MD5_VALUE = "SP_PARAM_GET_USER_MD5_VALUE";
        public const string SP_OUTPUT_GET_USER_COMPANY_ID = "SP_OUTPUT_GET_USER_COMPANY_ID";
        public const string SP_OUTPUT_GET_USER_USER_ID = "SP_OUTPUT_GET_USER_USER_ID";
        public const string SP_OUTPUT_GET_USER_NAME = "SP_OUTPUT_GET_USER_NAME";
        public const string SP_OUTPUT_GET_USER_LASTNAME1 = "SP_OUTPUT_GET_USER_LASTNAME1";
        public const string SP_OUTPUT_GET_USER_LASTNAME2 = "SP_OUTPUT_GET_USER_LASTNAME2";
        public const string SP_OUTPUT_GET_USER_LOGIN = "SP_OUTPUT_GET_USER_LOGIN";

        public const string SP_NAME_ADD_ACCOUNT_TO_ENTRY = "SP_NAME_ADD_ACCOUNT_TO_ENTRY";
        public const string SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_ID = "SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_ID";
        public const string SP_PARAM_ADD_ACCOUNT_TO_ENTRY_TRANSACTION_TYPE = "SP_PARAM_ADD_ACCOUNT_TO_ENTRY_TRANSACTION_TYPE";
        public const string SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_BALANCE = "SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_BALANCE";
        public const string SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_BALANCE_SYSTEM = "SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_BALANCE_SYSTEM";
        public const string SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_BALANCE_FOREIGN = "SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_BALANCE_FOREIGN";
        public const string SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_EXCHANGE_RATE = "SP_PARAM_ADD_ACCOUNT_TO_ENTRY_ACCOUNT_EXCHANGE_RATE";

        public const string SP_NAME_INSERT_COMPANY = "SP_NAME_INSERT_COMPANY";
        public const string SP_PARAM_INSERT_COMPANY_COMPANY_NAME = "SP_PARAM_INSERT_COMPANY_COMPANY_NAME";
        public const string SP_PARAM_INSERT_COMPANY_TAX_IDENTIFICATION = "SP_PARAM_INSERT_COMPANY_TAX_IDENTIFICATION";
        public const string SP_PARAM_INSERT_COMPANY_LOGO = "SP_PARAM_INSERT_COMPANY_LOGO";
        public const string SP_PARAM_INSERT_COMPANY_LOCAL_CURRENCY = "SP_PARAM_INSERT_COMPANY_LOCAL_CURRENCY";
        public const string SP_PARAM_INSERT_COMPANY_SYSTEM_CURRENCY = "SP_PARAM_INSERT_COMPANY_SYSTEM_CURRENCY";

        public const string SP_NAME_INSERT_ACCOUNT = "SP_NAME_INSERT_ACCOUNT";
        public const string SP_PARAM_INSERT_ACCOUNT_CODE = "SP_PARAM_INSERT_ACCOUNT_CODE";
        public const string SP_PARAM_INSERT_ACCOUNT_NAME = "SP_PARAM_INSERT_ACCOUNT_NAME";
        public const string SP_PARAM_INSERT_ACCOUNT_FOREIGN_NAME = "SP_PARAM_INSERT_ACCOUNT_FOREIGN_NAME";
        public const string SP_PARAM_INSERT_ACCOUNT_ACCOUNT_TYPE = "SP_PARAM_INSERT_ACCOUNT_ACCOUNT_TYPE";
        public const string SP_PARAM_INSERT_ACCOUNT_ACCOUNT_STATUS = "SP_PARAM_INSERT_ACCOUNT_ACCOUNT_STATUS";
        public const string SP_PARAM_INSERT_ACCOUNT_PARENT_ID = "SP_PARAM_INSERT_ACCOUNT_PARENT_ID";
        public const string SP_PARAM_INSERT_ACCOUNT_CURRENCY_ID = "SP_PARAM_INSERT_ACCOUNT_CURRENCY_ID";
        public const string SP_PARAM_INSERT_ACCOUNT_ACCOUNT_CATALOG = "SP_PARAM_INSERT_ACCOUNT_ACCOUNT_CATALOG";

        public const string SP_NAME_ERASE_ACCOUNT = "SP_NAME_ERASE_ACCOUNT";
        public const string SP_PARAM_ERASE_ACCOUNT_ACCOUNT_ID = "SP_PARAM_ERASE_ACCOUNT_ACCOUNT_ID";


        public const string SP_NAME_GET_ALL_ENTRIES = "SP_NAME_GET_ALL_ENTRIES";
        public const string SP_PARAM_GET_ALL_ENTRIES_COMPANY_ID = "SP_PARAM_GET_ALL_ENTRIES_COMPANY_ID";
        public const string SP_PARAM_GET_ALL_ENTRIES_START_DATE = "SP_PARAM_GET_ALL_ENTRIES_START_DATE";
        public const string SP_PARAM_GET_ALL_ENTRIES_END_DATE = "SP_PARAM_GET_ALL_ENTRIES_END_DATE";


        public const string SP_NAME_GET_COMPANIES = "SP_NAME_GET_COMPANIES";
        public const string SP_OUTPUT_GET_COMPANIES_COMPANY_ID = "SP_OUTPUT_GET_COMPANIES_COMPANY_ID";
        public const string SP_OUTPUT_GET_COMPANIES_COMPANY_NAME = "SP_OUTPUT_GET_COMPANIES_COMPANY_NAME";
        public const string SP_OUTPUT_GET_COMPANIES_COMPANY_TAX_IDENTIFICATION = "SP_OUTPUT_GET_COMPANIES_COMPANY_TAX_IDENTIFICATION";
        public const string SP_OUTPUT_GET_COMPANIES_COMPANY_LOGO = "SP_OUTPUT_GET_COMPANIES_COMPANY_LOGO";
        public const string SP_OUTPUT_GET_COMPANIES_SYSTEM_CURRENCY_ID = "SP_OUTPUT_GET_COMPANIES_SYSTEM_CURRENCY_ID";
        public const string SP_OUTPUT_GET_COMPANIES_LOCAL_CURRENCY_ID = "SP_OUTPUT_GET_COMPANIES_LOCAL_CURRENCY_ID";


        public const string SP_NAME_GET_COMPANY = "SP_NAME_GET_COMPANY";
        public const string SP_PARAM_GET_COMPANY_COMPANY_ID = "SP_PARAM_GET_COMPANY_COMPANY_ID";
        public const string SP_PARAM_GET_COMPANY_COMPANY_NAME = "SP_PARAM_GET_COMPANY_COMPANY_NAME";
        public const string SP_PARAM_GET_COMPANY_COMPANY_TAX_IDENTIFICATION = "SP_PARAM_GET_COMPANY_COMPANY_TAX_IDENTIFICATION";
        public const string SP_PARAM_GET_COMPANY_COMPANY_LOGO = "SP_PARAM_GET_COMPANY_COMPANY_LOGO";

        public const string SP_OUTPUT_ACTION_PERFORMED_RESULT = "SP_OUTPUT_ACTION_PERFORMED_RESULT";


        public const string SP_NAME_GET_ACCOUNTING_CATALOG = "SP_NAME_GET_ACCOUNTING_CATALOG";
        public const string SP_PARAM_GET_ACCOUNTING_CATALOG_COMPANY_ID = "SP_PARAM_GET_ACCOUNTING_CATALOG_COMPANY_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_CATALOG_ID = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_CATALOG_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_COMPANY_ID = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_COMPANY_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_ID = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_CODE = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_CODE";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_NAME = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_NAME";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_FOREIGN_NAME = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_FOREIGN_NAME";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_PARENT_ID = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_PARENT_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_TYPE = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_TYPE";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_STATUS = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_STATUS";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_LEVEL = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_LEVEL";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_CURRENCY_ID = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_CURRENCY_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_CURRENCY_NAME = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_CURRENCY_NAME";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_CURRENCY_MNEMONIC = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_CURRENCY_MNEMONIC";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_BALANCE_LOCAL = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_BALANCE_LOCAL";
        public const string SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_BALANCE_SYSTEM = "SP_OUTPUT_GET_ACCOUNTING_CATALOG_ACCOUNT_BALANCE_SYSTEM";


        public const string SP_NAME_VALID_USER = "SP_NAME_VALID_USER";
        public const string SP_PARAM_VALID_USER_LOGIN = "SP_PARAM_VALID_USER_LOGIN";

        public const string SP_NAME_INSERT_ACCOUNTING_CATALOG = "SP_NAME_INSERT_ACCOUNTING_CATALOG";
        public const string SP_PARAM_INSERT_ACCOUNTING_CATALOG_COMPANY_ID = "SP_PARAM_INSERT_ACCOUNTING_CATALOG_COMPANY_ID";
        public const string SP_OUTPUT_INSERT_ACCOUNTING_CATALOG_CATALOG_ID = "SP_OUTPUT_INSERT_ACCOUNTING_CATALOG_CATALOG_ID";

        public const string SP_NAME_ADD_PHONES_TO_COMPANY = "SP_NAME_ADD_PHONES_TO_COMPANY";
        public const string SP_PARAM_ADD_PHONES_TO_COMPANY_PHONE_TYPE = "SP_PARAM_ADD_PHONES_TO_COMPANY_PHONE_TYPE";
        public const string SP_PARAM_ADD_PHONES_TO_COMPANY_COMPANY_ID = "SP_PARAM_ADD_PHONES_TO_COMPANY_COMPANY_ID";
        public const string SP_PARAM_ADD_PHONES_TO_COMPANY_TELEFONO = "SP_PARAM_ADD_PHONES_TO_COMPANY_TELEFONO";

        

        public const string SP_NAME_GET_STATES = "SP_NAME_GET_STATES";
        public const string SP_PARAM_GET_STATES_COUNTRY_ID = "SP_PARAM_GET_STATES_COUNTRY_ID";

        public const string SP_OUTPUT_GET_STATES_STATE_ID = "SP_OUTPUT_GET_STATES_STATE_ID";
        public const string SP_OUTPUT_GET_STATES_COUNTRY_ID = "SP_OUTPUT_GET_STATES_COUNTRY_ID";
        public const string SP_OUTPUT_GET_STATES_NOMBRE = "SP_OUTPUT_GET_STATES_NOMBRE";

        public const string SP_NAME_GET_COUNTRIES = "SP_NAME_GET_COUNTRIES";
        public const string SP_OUTPUT_GET_COUNTRIES_COUNTRY_ID = "SP_OUTPUT_GET_COUNTRIES_COUNTRY_ID";
        public const string SP_OUTPUT_GET_COUNTRIES_NOMBRE = "SP_OUTPUT_GET_COUNTRIES_NOMBRE";


        public const string SP_NAME_GET_ADDRESS = "SP_NAME_GET_ADDRESS";
        public const string SP_PARAM_GET_ADDRESS_USER_ID = "SP_PARAM_GET_ADDRESS_USER_ID";
        public const string SP_OUTPUT_GET_ADDRESS_CITY = "SP_OUTPUT_GET_ADDRESS_CITY";
        public const string SP_OUTPUT_GET_ADDRESS_STATE = "SP_OUTPUT_GET_ADDRESS_STATE";
        public const string SP_OUTPUT_GET_ADDRESS_COUNTRY = "SP_OUTPUT_GET_ADDRESS_COUNTRY";
        
        public const string SP_NAME_GET_CITIES = "SP_NAME_GET_CITIES";
        public const string SP_PARAM_GET_CITIES_STATE_ID = "SP_PARAM_GET_CITIES_STATE_ID";
        public const string SP_OUTPUT_GET_CITIES_CITY_ID = "SP_OUTPUT_GET_CITIES_CITY_ID";
        public const string SP_OUTPUT_GET_CITIES_CITY_NAME = "SP_OUTPUT_GET_CITIES_CITY_NAME";
        
        public const string SP_NAME_INSERT_ACCOUNTING_PERIOD = "SP_NAME_INSERT_ACCOUNTING_PERIOD";
        public const string SP_PARAM_INSERT_ACCOUNTING_PERIOD_COMPANY_ID = "SP_PARAM_INSERT_ACCOUNTING_PERIOD_COMPANY_ID";
        public const string SP_OUTPUT_INSERT_ACCOUNTING_PERIOD_PERIOD_TYPE = "SP_OUTPUT_INSERT_ACCOUNTING_PERIOD_PERIOD_TYPE";
        public const string SP_OUTPUT_INSERT_ACCOUNTING_PERIOD_DESCRIPTION = "SP_OUTPUT_INSERT_ACCOUNTING_PERIOD_DESCRIPTION";
        public const string SP_OUTPUT_ACCOUNT_CATALOG_ID = "SP_OUTPUT_ACCOUNT_CATALOG_ID";
        
        public const string SP_NAME_GET_CURRENCIES = "SP_NAME_GET_CURRENCIES";
        public const string SP_OUTPUT_GET_CURRENCIES_CURRENCY_ID = "SP_OUTPUT_GET_CURRENCIES_CURRENCY_ID";
        public const string SP_OUTPUT_GET_CURRENCIES_CURRENCY_NAME = "SP_OUTPUT_GET_CURRENCIES_CURRENCY_NAME";
        public const string SP_OUTPUT_GET_CURRENCIES_CURRENCY_MNEMONIC = "SP_OUTPUT_GET_CURRENCIES_CURRENCY_MNEMONIC";
        public const string SP_OUTPUT_GET_CURRENCIES_CURRENCY_SYMBOL = "SP_OUTPUT_GET_CURRENCIES_CURRENCY_SYMBOL";

        public const string SP_NAME_GET_ACCOUNTING_PERIODS = "SP_NAME_GET_ACCOUNTING_PERIODS";
        public const string SP_PARAM_GET_ACCOUNTING_PERIODS_COMPANY_ID = "SP_PARAM_GET_ACCOUNTING_PERIODS_COMPANY_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_PERIODS_PERIOD_ID = "SP_OUTPUT_GET_ACCOUNTING_PERIODS_PERIOD_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_PERIODS_PERIOD_TYPE = "SP_OUTPUT_GET_ACCOUNTING_PERIODS_PERIOD_TYPE";
        public const string SP_OUTPUT_GET_ACCOUNTING_PERIODS_DESCRIPTION = "SP_OUTPUT_GET_ACCOUNTING_PERIODS_DESCRIPTION";
        public const string SP_OUTPUT_GET_ACCOUNTING_PERIODS_LOCAL_BALANCE = "SP_OUTPUT_GET_ACCOUNTING_PERIODS_LOCAL_BALANCE";
        public const string SP_OUTPUT_GET_ACCOUNTING_PERIODS_SYSTEM_BALANCE = "SP_OUTPUT_GET_ACCOUNTING_PERIODS_SYSTEM_BALANCE";

        public const string SP_NAME_GET_ACCOUNTING_MONTHS = "SP_NAME_GET_ACCOUNTING_MONTHS";
        public const string SP_PARAM_GET_ACCOUNTING_MONTHS_PERIOD_ID = "SP_PARAM_GET_ACCOUNTING_MONTHS_PERIOD_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_ID = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_PERIOD_ID = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_PERIOD_ID";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_STATUS = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_STATUS";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_START_DATE = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_START_DATE";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_END_DATE = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_MONTH_END_DATE";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_GOODTHRU_DATE = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_GOODTHRU_DATE";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_VALIDSINCE_DATE = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_VALIDSINCE_DATE";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_LOCAL_BALANCE = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_LOCAL_BALANCE";
        public const string SP_OUTPUT_GET_ACCOUNTING_MONTHS_SYSTEM_BALANCE = "SP_OUTPUT_GET_ACCOUNTING_MONTHS_SYSTEM_BALANCE";
        
        public const string SP_NAME_CHANGE_MONTH_STATUS = "SP_NAME_CHANGE_MONTH_STATUS";
        public const string SP_PARAM_CHANGE_MONTH_STATUS_MONTH_ID = "SP_PARAM_CHANGE_MONTH_STATUS_MONTH_ID";
        public const string SP_PARAM_CHANGE_MONTH_STATUS_MONTH_STATUS = "SP_PARAM_CHANGE_MONTH_STATUS_MONTH_STATUS";

        public const string SP_NAME_CHANGE_ACCOUNT_CURRENCY = "SP_NAME_CHANGE_ACCOUNT_CURRENCY";
        public const string SP_PARAM_CHANGE_ACCOUNT_CURRENCY_ACCOUNT_ID = "SP_PARAM_CHANGE_ACCOUNT_CURRENCY_ACCOUNT_ID";
        public const string SP_PARAM_CHANGE_ACCOUNT_CURRENCY_CURRENCY_NAME = "SP_PARAM_CHANGE_ACCOUNT_CURRENCY_CURRENCY_NAME";

        public const string SP_NAME_CHANGE_ACCOUNT_INFORMATION = "SP_NAME_CHANGE_ACCOUNT_INFORMATION";
        public const string SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_ID = "SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_ID";
        public const string SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_CODE = "SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_CODE";
        public const string SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_NAME = "SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_NAME";
        public const string SP_PARAM_CHANGE_ACCOUNT_INFORMATION_FOREIGN_NAME = "SP_PARAM_CHANGE_ACCOUNT_INFORMATION_FOREIGN_NAME";
        public const string SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_STATUS = "SP_PARAM_CHANGE_ACCOUNT_INFORMATION_ACCOUNT_STATUS";
        public const string SP_PARAM_CHANGE_ACCOUNT_INFORMATION_CURRENCY_NAME = "SP_PARAM_CHANGE_ACCOUNT_INFORMATION_CURRENCY_NAME";

        
        public const string SP_NAME_CHANGE_ACCOUNT_STATUS = "SP_NAME_CHANGE_ACCOUNT_STATUS";
        public const string SP_PARAM_CHANGE_ACCOUNT_STATUS_ACCOUNT_ID = "SP_PARAM_CHANGE_ACCOUNT_STATUS_ACCOUNT_ID";
        public const string SP_PARAM_CHANGE_ACCOUNT_STATUS_ACCOUNT_STATUS = "SP_PARAM_CHANGE_ACCOUNT_STATUS_ACCOUNT_STATUS";
        
        public const string SP_NAME_INSERT_CURRENCY = "SP_NAME_INSERT_CURRENCY";
        public const string SP_PARAM_INSERT_CURRENCY_CURRENCY_NAME = "SP_PARAM_INSERT_CURRENCY_CURRENCY_NAME";
        public const string SP_PARAM_INSERT_CURRENCY_CURRENCY_MNEMONIC = "SP_PARAM_INSERT_CURRENCY_CURRENCY_MNEMONIC";

        public const string SP_NAME_BALANCE_SHEET = "SP_NAME_BALANCE_SHEET";
        public const string SP_NAME_INCOME_STATEMENT = "SP_NAME_INCOME_STATEMENT";
        public const string SP_NAME_GENERAL_BALANCE = "SP_NAME_GENERAL_BALANCE";


        public const string SP_NAME_GET_COMPANY_CURRENCIES = "SP_NAME_GET_COMPANY_CURRENCIES";
        public const string SP_PARAM_GET_COMPANY_CURRENCIES_COMPANY_ID = "SP_PARAM_GET_COMPANY_CURRENCIES_COMPANY_ID";
        public const string SP_OUTPUT_GET_COMPANY_CURRENCIES_CURRENCY_ID = "SP_OUTPUT_GET_COMPANY_CURRENCIES_CURRENCY_ID";
        public const string SP_OUTPUT_GET_COMPANY_CURRENCIES_CURRENCY_TYPE = "SP_OUTPUT_GET_COMPANY_CURRENCIES_CURRENCY_TYPE";


        public const string SP_NAME_ERASE_ENTRY = "SP_NAME_ERASE_ENTRY";
        public const string SP_PARAM_ERASE_ENTRY_ENTRY_ID = "SP_PARAM_ERASE_ENTRY_ENTRY_ID";


        #endregion

        

    }
}
